ALTER TABLE [dbo].[actionablealertsmessage]   ADD programofficer int;
	ALTER TABLE [dbo].[actionablealertsmessage]   ADD regionaldirector int;
	ALTER TABLE [dbo].[actionablealertsmessage]   ADD programassistant int;
	ALTER TABLE [dbo].[actionablealertsmessage]   ADD regionid int;
	
	
ALTER TABLE [dbo].[actionablealertsmessage]   ADD  CONSTRAINT [FKuserid1] FOREIGN KEY([programofficer])
REFERENCES [dbo].[userinfo] ([id])
GO

ALTER TABLE [dbo].[actionablealertsmessage]   ADD  CONSTRAINT [FKuserid2] FOREIGN KEY([regionaldirector])
REFERENCES [dbo].[userinfo] ([id])
GO

ALTER TABLE [dbo].[actionablealertsmessage]   ADD  CONSTRAINT [FKuserid3] FOREIGN KEY([programassistant])
REFERENCES [dbo].[userinfo] ([id])
GO

ALTER TABLE [dbo].[actionablealertsmessage]   ADD  CONSTRAINT [FKreagionid] FOREIGN KEY([regionid])
REFERENCES [dbo].[region] ([id])
GO

ALTER TABLE [dbo].[Cacheactionablealertsmessage]   ADD programofficer int;
	ALTER TABLE [dbo].[Cacheactionablealertsmessage]   ADD regionaldirector int;
	ALTER TABLE [dbo].[Cacheactionablealertsmessage]   ADD programassistant int;
	ALTER TABLE [dbo].[Cacheactionablealertsmessage]   ADD regionid int;
	
	
ALTER TABLE [dbo].[Cacheactionablealertsmessage]   ADD  CONSTRAINT [FKcauserid1] FOREIGN KEY([programofficer])
REFERENCES [dbo].[userinfo] ([id])
GO

ALTER TABLE [dbo].[Cacheactionablealertsmessage]   ADD  CONSTRAINT [FKcauserid2] FOREIGN KEY([regionaldirector])
REFERENCES [dbo].[userinfo] ([id])
GO

ALTER TABLE [dbo].[Cacheactionablealertsmessage]   ADD  CONSTRAINT [FKcauserid3] FOREIGN KEY([programassistant])
REFERENCES [dbo].[userinfo] ([id])
GO

ALTER TABLE [dbo].[Cacheactionablealertsmessage]   ADD  CONSTRAINT [FKcareagionid] FOREIGN KEY([regionid])
REFERENCES [dbo].[region] ([id])
GO
	